Release 10.1A: OpenEdge Data Management:
SQL Reference

ROUND

Returns the rounded value of a numeric expression.

Syntax

ROUND ( num_expression [, rounding_factor ] ) ;

Example

This example illustrates four calls to the ROUND function:

-- rounding_factor 2 returns 2953861.83 ROUND ( 2953861.8320, 2 ) -- rounding_factor -2 returns 2953900.00 ROUND ( 2953861.8320, -2 ) -- rounding_factor 0 returns 2953862.00 ROUND ( 2953861.8320, 0 ) -- No rounding_factor argument also returns 2953862.00 ROUND ( 2953861.8320 )

In each case the num_expression is 2953861.8320. In the first call the rounding_factor is 2, in the second call the rounding_factor is -2, in the third call the rounding_factor is 0, and in the fourth call no rounding_factor is specified.

Notes

num_expression must be numeric or must be convertible to numeric.
num_expression must be one of these supported data types:
INTEGER
TINYINT
SMALLINT
NUMBER
FLOAT
DOUBLE PRECISION
If the data type of num_expression is not a supported type, ROUND returns an error message.
The num_expression is rounded to the next higher digit when:
The digit before a negative rounding_factor is 5 or greater.
The digit after a positive rounding_factor is 5 or greater.
The num_expression is rounded to the next lower digit when:
The digit before a negative rounding_factor is 4 or less.
The digit after a positive rounding_factor is 4 or less.
rounding_factor is an integer between –32 and +32 inclusive, and indicates the digit position to which you want to round num_expression. Figure 1 illustrates how the digit positions are numbered. In the figure, the num_expression is 2953861.8320.



Figure 1: ROUND digit positions
If you do not specify a rounding_factor, the function rounds num_expression to digit 0 (the ones place).
To round to the right of the decimal point, specify a positive rounding_factor.
To round to the left of the decimal, specify a negative rounding_factor.

Compatibility

Progress extension